﻿USE [T2Logging]

DELETE FROM [dbo].[Log]
DELETE FROM [dbo].[LogCategory]
DELETE FROM [dbo].[Application]
DELETE FROM [dbo].[Tenant]

DBCC CHECKIDENT ('Tenant')
DBCC CHECKIDENT ('Application')
DBCC CHECKIDENT ('LogCategory')
DBCC CHECKIDENT ('Log')

SET IDENTITY_INSERT [dbo].[Tenant] ON
INSERT INTO [dbo].[Tenant] ([TenantID], [TenantName], [CreatedBy], [CreatedDt], [ModifiedBy], [ModifiedDt]) VALUES (1, N'Tenant', N'trooks', N'2013-09-17 00:00:00', N'trooks', N'2013-09-17 00:00:00')
SET IDENTITY_INSERT [dbo].[Tenant] OFF

SET IDENTITY_INSERT [dbo].[Application] ON
INSERT INTO [dbo].[Application] ([ApplicationID], [ApplicationName], [CreatedBy], [CreatedDt], [ModifiedBy], [ModifiedDt], [TenantID]) VALUES (1, N'T2.Medussa', N'trooks', N'2013-09-17 14:59:23', N'trooks', N'2013-09-17 14:59:23', 1)
SET IDENTITY_INSERT [dbo].[Application] OFF

SET IDENTITY_INSERT [dbo].[LogCategory] ON
INSERT INTO [dbo].[LogCategory] ([LogCategoryID], [LogCategoryName], [CreatedBy], [CreatedDt], [ModifiedBy], [ModifiedDt]) VALUES (0, N'Error', N'trooks', N'2013-09-18 14:35:46', N'trooks', N'2013-09-18 14:35:53')
INSERT INTO [dbo].[LogCategory] ([LogCategoryID], [LogCategoryName], [CreatedBy], [CreatedDt], [ModifiedBy], [ModifiedDt]) VALUES (1, N'LogToDb', N'trooks', N'2013-09-18 14:35:46', N'trooks', N'2013-09-18 14:35:53')
SET IDENTITY_INSERT [dbo].[LogCategory] OFF

SET IDENTITY_INSERT [dbo].[Log] ON
INSERT INTO [dbo].[Log] ([LogID], [Priority], [Severity], [Title], [MachineName], [AppDomainName], [Message], [CreatedBy], [CreatedDt], [ModifiedBy], [ModifiedDt], [ApplicationID], [LogCategoryID]) VALUES (1, 1, N'Critical', N'Log Title', N'', N'appA', N'log1 message', N'user', N'2013-09-18 16:31:40', N'user', N'2013-09-18 16:31:42', 1, 0)
INSERT INTO [dbo].[Log] ([LogID], [Priority], [Severity], [Title], [MachineName], [AppDomainName], [Message], [CreatedBy], [CreatedDt], [ModifiedBy], [ModifiedDt], [ApplicationID], [LogCategoryID]) VALUES (2, 1, N'Critical', N'Log Title45', N'', N'appA', N'log2 message', N'user', N'2013-09-18 16:43:24', N'user', N'2013-09-18 16:43:24', 1, 0)
INSERT INTO [dbo].[Log] ([LogID], [Priority], [Severity], [Title], [MachineName], [AppDomainName], [Message], [CreatedBy], [CreatedDt], [ModifiedBy], [ModifiedDt], [ApplicationID], [LogCategoryID]) VALUES (3, 10, N'Information', N'Password Changed for trooks', N'', N'T2.Medussa', N'Password Changed for trooks', N'MVC4', N'2013-09-19 10:13:30', N'MVC4', N'2013-09-19 10:13:31', 1, 0)
INSERT INTO [dbo].[Log] ([LogID], [Priority], [Severity], [Title], [MachineName], [AppDomainName], [Message], [CreatedBy], [CreatedDt], [ModifiedBy], [ModifiedDt], [ApplicationID], [LogCategoryID]) VALUES (4, 1, N'Critical', N'Log Title', N'', N'appA', N'log1 message', N'user', N'2013-09-18 16:31:40', N'user', N'2013-09-18 16:31:42', 1, 0)
INSERT INTO [dbo].[Log] ([LogID], [Priority], [Severity], [Title], [MachineName], [AppDomainName], [Message], [CreatedBy], [CreatedDt], [ModifiedBy], [ModifiedDt], [ApplicationID], [LogCategoryID]) VALUES (5, 1, N'Critical', N'Log Title45', N'', N'appA', N'log2 message', N'user', N'2013-09-18 16:43:24', N'user', N'2013-09-18 16:43:24', 1, 0)
INSERT INTO [dbo].[Log] ([LogID], [Priority], [Severity], [Title], [MachineName], [AppDomainName], [Message], [CreatedBy], [CreatedDt], [ModifiedBy], [ModifiedDt], [ApplicationID], [LogCategoryID]) VALUES (6, 10, N'Information', N'Password Changed for trooks', N'', N'T2.Medussa', N'Password Changed for trooks', N'MVC4', N'2013-09-19 10:13:30', N'MVC4', N'2013-09-19 10:13:31', 1, 1)
INSERT INTO [dbo].[Log] ([LogID], [Priority], [Severity], [Title], [MachineName], [AppDomainName], [Message], [CreatedBy], [CreatedDt], [ModifiedBy], [ModifiedDt], [ApplicationID], [LogCategoryID]) VALUES (7, 1, N'Critical', N'Log Title', N'', N'appA', N'log1 message', N'user', N'2013-09-18 16:31:40', N'user', N'2013-09-18 16:31:42', 1, 0)
INSERT INTO [dbo].[Log] ([LogID], [Priority], [Severity], [Title], [MachineName], [AppDomainName], [Message], [CreatedBy], [CreatedDt], [ModifiedBy], [ModifiedDt], [ApplicationID], [LogCategoryID]) VALUES (8, 1, N'Critical', N'Log Title45', N'', N'appA', N'log2 message', N'user', N'2013-09-18 16:43:24', N'user', N'2013-09-18 16:43:24', 1, 1)
INSERT INTO [dbo].[Log] ([LogID], [Priority], [Severity], [Title], [MachineName], [AppDomainName], [Message], [CreatedBy], [CreatedDt], [ModifiedBy], [ModifiedDt], [ApplicationID], [LogCategoryID]) VALUES (9, 10, N'Information', N'Password Changed for trooks', N'', N'T2.Medussa', N'Password Changed for trooks', N'MVC4', N'2013-09-19 10:13:30', N'MVC4', N'2013-09-19 10:13:31', 1, 0)
SET IDENTITY_INSERT [dbo].[Log] OFF